SELECT c_city, s_city, d_year, SUM(lo_revenue) AS lo_revenue
FROM p_lineorder LEFT JOIN dates ON lo_orderdate = d_datekey LEFT JOIN customer ON lo_custkey = c_custkey LEFT JOIN supplier ON lo_suppkey = s_suppkey
WHERE(c_city = 'CHINA    001'
        OR c_city = 'CHINA    100')
    AND (s_city = 'EGYPT    001'
        OR s_city = 'EGYPT   033')
    AND d_yearmonth LIKE '%1997'
GROUP BY c_city, s_city, d_year
ORDER BY d_year ASC, lo_revenue DESC